---
title: SAIF.Business.Claim.Legal database tables
summary: Database tables used by this library with relationships and usage context.
status: draft
owner: SAIF Documentation Generator
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# SAIF.Business.Claim.Legal database tables

This page catalogs the 51 database tables and views accessed by this library. Schema is recorded as `[unqualified]**` wherever the source references the object without a schema prefix (the overwhelming majority — the BOF data portal resolves the schema through the connecting Oracle user at runtime). Only two references are explicitly qualified (`LEGAL.ATTORNEY_PROFILE`, `LEGAL.VW_CASES`).

## Table catalog

| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [ADP_EMPLOYEE](#adp_employee) | Oracle | `[unqualified]**` | R | Attorney / staff lookup joins | `Attorney / staff lookup joins` |
| [ALL_STATES](#all_states) | Oracle | `[unqualified]**` | R | State code list | `State code list` |
| [APPEAL_EXTENSION](#appeal_extension) | Oracle | `[unqualified]**` | CRU | clsAppealExtension | `clsAppealExtension` |
| [ATTORNEY_CONFLICT](#attorney_conflict) | Oracle | `[unqualified]**` | CRUD | clsAttorneyConflict, clsAttorneyConflictCollection | `clsAttorneyConflict` |
| [ATTORNEY_POLICY_ASSIGNMENT](#attorney_policy_assignment) | Oracle | `[unqualified]**` | CRUD | clsAttorneyPolicyAssignment (+collection) | `clsAttorneyPolicyAssignment` |
| [ATTORNEY_PROFILE](#attorney_profile) | Oracle | `[unqualified]**` | CRU | clsAttorneyProfile | `clsAttorneyProfile` |
| [LEGAL.ATTORNEY_PROFILE](#legalattorney_profile) | Oracle | `LEGAL` | R | clsAttorneyProfile (explicitly qualified read) | `clsAttorneyProfile` |
| [ATTORNEY_SCHEDULE](#attorney_schedule) | Oracle | `[unqualified]**` | CRUD | clsAttorneySchedule (+collection) | `clsAttorneySchedule` |
| [ATTORNEY_SCHEDULE_TYPE_CODE](#attorney_schedule_type_code) | Oracle | `[unqualified]**` | R | clsAttorneyScheduleTypeCodes | `clsAttorneyScheduleTypeCodes` |
| [ATTORNEY_TYPE_CODE](#attorney_type_code) | Oracle | `[unqualified]**` | R | clsAttorneyTypeCodes | `clsAttorneyTypeCodes` |
| [ATTORNEY_WORKER_ASSIGNMENT](#attorney_worker_assignment) | Oracle | `[unqualified]**` | CRUD | clsAttorneyWorkerAssignment (+collection) | `clsAttorneyWorkerAssignment` |
| [CANCELLED_BY_CODE](#cancelled_by_code) | Oracle | `[unqualified]**` | R | clsCancelledByCodes | `clsCancelledByCodes` |
| [CASE_COST](#case_cost) | Oracle | `[unqualified]**` | CRUD | clsCaseCost (+collection) | `clsCaseCost` |
| [CASE_STATUS_CODE](#case_status_code) | Oracle | `[unqualified]**` | R | clsCaseStatusCodes | `clsCaseStatusCodes` |
| [CASE_STATUS_HISTORY](#case_status_history) | Oracle | `[unqualified]**` | CRUD | clsCaseStatusHistory (+collection) | `clsCaseStatusHistory` |
| [DUAL](#dual) | Oracle | `[unqualified]**` | R | Sequence NEXTVAL pseudo-table | `Sequence NEXTVAL pseudo-table` |
| [DURATION_CODE](#duration_code) | Oracle | `[unqualified]**` | R | clsDurationCodes | `clsDurationCodes` |
| [HEARING_LOCATION](#hearing_location) | Oracle | `[unqualified]**` | CRUD | clsHearingLocation (+collection), clsHearingLocationInfo | `clsHearingLocation` |
| [HEARING_LOCATION_CODE](#hearing_location_code) | Oracle | `[unqualified]**` | R | clsHearingLocationCodes, clsHearingLocationList | `clsHearingLocationCodes` |
| [LEGAL_BODY_PART_CODE](#legal_body_part_code) | Oracle | `[unqualified]**` | R | clsBodyPartCodes | `clsBodyPartCodes` |
| [LEGAL_CASE_EMPLOYER](#legal_case_employer) | Oracle | `[unqualified]**` | CRUD | clsLegalCaseEmployer (+collection) | `clsLegalCaseEmployer` |
| [LEGAL_CASE_EVALUATION](#legal_case_evaluation) | Oracle | `[unqualified]**` | CRU | clsLegalCaseEvaluation (+collection) | `clsLegalCaseEvaluation` |
| [LEGAL_FILE_LOCATION](#legal_file_location) | Oracle | `[unqualified]**` | CRUD | clsLegalFileLocation (+collection) | `clsLegalFileLocation` |
| [LEGAL_FILE_LOCATION_CODE](#legal_file_location_code) | Oracle | `[unqualified]**` | R | clsFileLocationCodes | `clsFileLocationCodes` |
| [LEGAL_PERSON](#legal_person) | Oracle | `[unqualified]**` | CRUD | clsLegalPerson, clsLegalPersonList | `clsLegalPerson` |
| [LEGAL_PERSON_TYPE](#legal_person_type) | Oracle | `[unqualified]**` | CRUD | clsLegalPersonType (+collection) | `clsLegalPersonType` |
| [LEGAL_PERSON_TYPE_CODE](#legal_person_type_code) | Oracle | `[unqualified]**` | R | clsLegalPersonType, person-type lookups | `clsLegalPersonType` |
| [LEGAL.VW_CASES](#legalvw_cases) | Oracle | `LEGAL` | R | clsLetterRequest case lookup (view) | `clsLetterRequest case lookup` |
| [NATURE_CODE](#nature_code) | Oracle | `[unqualified]**` | R | clsNatureCodes | `clsNatureCodes` |
| [NOTE_CATEGORY_CODE](#note_category_code) | Oracle | `[unqualified]**` | R | clsNoteCategoryCodes | `clsNoteCategoryCodes` |
| [ORDER_TYPE_CODE](#order_type_code) | Oracle | `[unqualified]**` | R | clsOrderTypeCodes | `clsOrderTypeCodes` |
| [OTHER_FIRM](#other_firm) | Oracle | `[unqualified]**` | CRUD | clsOtherFirm (+collection) | `clsOtherFirm` |
| [OTHER_FIRM_TYPE_CODE](#other_firm_type_code) | Oracle | `[unqualified]**` | R | clsOtherFirmTypeCodes | `clsOtherFirmTypeCodes` |
| [OUTCOME_GROUNDS_CODE](#outcome_grounds_code) | Oracle | `[unqualified]**` | R | clsOutcomeGroundsCodes | `clsOutcomeGroundsCodes` |
| [OUTCOME_ISSUE](#outcome_issue) | Oracle | `[unqualified]**` | CRUD | clsOutcomeIssue (+collection) | `clsOutcomeIssue` |
| [OUTCOME_ISSUE_CODE](#outcome_issue_code) | Oracle | `[unqualified]**` | R | clsOutcomeIssueCodes | `clsOutcomeIssueCodes` |
| [OUTCOME_STAFF](#outcome_staff) | Oracle | `[unqualified]**` | CRUD | clsOutcomeStaff (+collection) | `clsOutcomeStaff` |
| [OUT_OF_TOWN_ROTATION_ASSGN](#out_of_town_rotation_assgn) | Oracle | `[unqualified]**` | CRUD | clsOutOFTownRotationAssgn (+collection) | `clsOutOFTownRotationAssgn` |
| [PETITIONER_RESPONDENT_CODE](#petitioner_respondent_code) | Oracle | `[unqualified]**` | R | clsPetitionerRespondentCodes | `clsPetitionerRespondentCodes` |
| [POLICY](#policy) | Oracle | `[unqualified]**` | R | Policy join for conflicts / policy assignment | `Policy join for conflicts / policy assignment` |
| [PROVIDER_LOCATION](#provider_location) | Oracle | `[unqualified]**` | R | Outside-counsel firm location join | `Outside-counsel firm location join` |
| [REQUESTED_BY_CODE](#requested_by_code) | Oracle | `[unqualified]**` | R | clsRequestedByCodes | `clsRequestedByCodes` |
| [REQUEST_ISSUE](#request_issue) | Oracle | `[unqualified]**` | CRUD | clsRequestIssue (+collection) | `clsRequestIssue` |
| [REQUEST_ISSUE_CODE](#request_issue_code) | Oracle | `[unqualified]**` | R | clsRequestIssueCodes | `clsRequestIssueCodes` |
| [REQUEST_TYPE_CODE](#request_type_code) | Oracle | `[unqualified]**` | R | clsRequestTypeCodes | `clsRequestTypeCodes` |
| [REVIEW_LEVEL_CODE](#review_level_code) | Oracle | `[unqualified]**` | R | clsReviewLevelCodes | `clsReviewLevelCodes` |
| [SCHEDULE](#schedule) | Oracle | `[unqualified]**` | R | clsLegalSchedule, clsHearingLocation.CanDeleteLocation | `clsLegalSchedule` |
| [SCHEDULE_STATUS_CODE](#schedule_status_code) | Oracle | `[unqualified]**` | R | clsScheduleStatusCodes | `clsScheduleStatusCodes` |
| [SCHEDULE_TYPE_CODE](#schedule_type_code) | Oracle | `[unqualified]**` | R | clsScheduleTypeCodes | `clsScheduleTypeCodes` |
| [SERVICE_CODE](#service_code) | Oracle | `[unqualified]**` | R | clsServiceCodes | `clsServiceCodes` |
| [SUBPOENA_RECIPIENT](#subpoena_recipient) | Oracle | `[unqualified]**` | R | clsLegalPerson delete-guard (NOT EXISTS) | `clsLegalPerson delete-guard` |


## ADP_EMPLOYEE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by Attorney / staff lookup joins |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `Attorney / staff lookup joins` |

### Sources for ADP_EMPLOYEE
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb`
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyPolicyAssignment.vb`
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneySchedule.vb`
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyWorkerAssignment.vb`
- `SAIF.Business.Claim.Legal\TableMaint\clsOutOFTownRotationAssgn.vb`
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## ALL_STATES

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by State code list |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `State code list` |

### Sources for ALL_STATES
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## APPEAL_EXTENSION

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsAppealExtension |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Create, Read, Update |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | APPEAL_EXTENSION_SEQ |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsAppealExtension` |

### Sources for APPEAL_EXTENSION
- `SAIF.Business.Claim.Legal\LegalNet\clsAppealExtension.vb`

---

## ATTORNEY_CONFLICT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsAttorneyConflict, clsAttorneyConflictCollection |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | ATTORNEY_CONFLICT_SEQ_NUM |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsAttorneyConflict, clsAttorneyConflictCollection` |

### Sources for ATTORNEY_CONFLICT
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb`

---

## ATTORNEY_POLICY_ASSIGNMENT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsAttorneyPolicyAssignment (+collection) |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | ATTY_POLICY_ASSGN_SEQ_NUM |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsAttorneyPolicyAssignment (+collection)` |

### Sources for ATTORNEY_POLICY_ASSIGNMENT
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyPolicyAssignment.vb`

---

## ATTORNEY_PROFILE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsAttorneyProfile |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Create, Read, Update |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — (proc-managed) |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsAttorneyProfile` |

### Sources for ATTORNEY_PROFILE
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyProfile.vb`
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## LEGAL.ATTORNEY_PROFILE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `LEGAL` |
| **Purpose** | Used by clsAttorneyProfile (explicitly qualified read) |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsAttorneyProfile (explicitly qualified read)` |

### Sources for LEGAL.ATTORNEY_PROFILE
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyProfile.vb:587`

---

## ATTORNEY_SCHEDULE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsAttorneySchedule (+collection) |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | ATTORNEY_SCHEDULE_SEQ_NUM |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsAttorneySchedule (+collection)` |

### Sources for ATTORNEY_SCHEDULE
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneySchedule.vb`

---

## ATTORNEY_SCHEDULE_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsAttorneyScheduleTypeCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsAttorneyScheduleTypeCodes` |

### Sources for ATTORNEY_SCHEDULE_TYPE_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## ATTORNEY_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsAttorneyTypeCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsAttorneyTypeCodes` |

### Sources for ATTORNEY_TYPE_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## ATTORNEY_WORKER_ASSIGNMENT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsAttorneyWorkerAssignment (+collection) |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | ATTORNEY_WORKER_ASSIGNMENT_SEQ |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsAttorneyWorkerAssignment (+collection)` |

### Sources for ATTORNEY_WORKER_ASSIGNMENT
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyWorkerAssignment.vb`

---

## CANCELLED_BY_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsCancelledByCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsCancelledByCodes` |

### Sources for CANCELLED_BY_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## CASE_COST

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsCaseCost (+collection) |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | CASE_COST_SEQ |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsCaseCost (+collection)` |

### Sources for CASE_COST
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseCost.vb`

---

## CASE_STATUS_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsCaseStatusCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsCaseStatusCodes` |

### Sources for CASE_STATUS_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## CASE_STATUS_HISTORY

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsCaseStatusHistory (+collection) |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | CASE_STATUS_HISTORY_SEQ |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsCaseStatusHistory (+collection)` |

### Sources for CASE_STATUS_HISTORY
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseStatusHistory.vb`

---

## DUAL

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by Sequence NEXTVAL pseudo-table |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `Sequence NEXTVAL pseudo-table` |

### Sources for DUAL
- `SAIF.Business.Claim.Legal\13 CreateSQL properties (see SQL-001 through SQL-013)`

---

## DURATION_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsDurationCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsDurationCodes` |

### Sources for DURATION_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## HEARING_LOCATION

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsHearingLocation (+collection), clsHearingLocationInfo |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | HEARING_LOCATION_SEQ_NUM |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsHearingLocation (+collection), clsHearingLocationInfo` |

### Sources for HEARING_LOCATION
- `SAIF.Business.Claim.Legal\TableMaint\clsHearingLocation.vb`
- `SAIF.Business.Claim.Legal\LegalNet\clsHearingLocationInfo.vb`

---

## HEARING_LOCATION_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsHearingLocationCodes, clsHearingLocationList |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsHearingLocationCodes, clsHearingLocationList` |

### Sources for HEARING_LOCATION_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`
- `SAIF.Business.Claim.Legal\TableMaint\clsHearingLocation.vb`

---

## LEGAL_BODY_PART_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsBodyPartCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsBodyPartCodes` |

### Sources for LEGAL_BODY_PART_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## LEGAL_CASE_EMPLOYER

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsLegalCaseEmployer (+collection) |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | LEGAL_CASE_EMPLOYER_SEQ |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsLegalCaseEmployer (+collection)` |

### Sources for LEGAL_CASE_EMPLOYER
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEmployer.vb`

---

## LEGAL_CASE_EVALUATION

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsLegalCaseEvaluation (+collection) |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Create, Read, Update |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | LEGAL_CASE_EVALUATION_SEQ |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsLegalCaseEvaluation (+collection)` |

### Sources for LEGAL_CASE_EVALUATION
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEvaluation.vb`

---

## LEGAL_FILE_LOCATION

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsLegalFileLocation (+collection) |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | LEGAL_FILE_LOCATION_SEQ |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsLegalFileLocation (+collection)` |

### Sources for LEGAL_FILE_LOCATION
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalFileLocation.vb`

---

## LEGAL_FILE_LOCATION_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsFileLocationCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsFileLocationCodes` |

### Sources for LEGAL_FILE_LOCATION_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## LEGAL_PERSON

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsLegalPerson, clsLegalPersonList |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | LEGAL_PERSON_SEQ_NUM |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsLegalPerson, clsLegalPersonList` |

### Sources for LEGAL_PERSON
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPerson.vb`
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPersonList.vb`

---

## LEGAL_PERSON_TYPE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsLegalPersonType (+collection) |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | LEGAL_PERSON_SEQ_NUM |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsLegalPersonType (+collection)` |

### Sources for LEGAL_PERSON_TYPE
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPersonType.vb`

---

## LEGAL_PERSON_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsLegalPersonType, person-type lookups |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsLegalPersonType, person-type lookups` |

### Sources for LEGAL_PERSON_TYPE_CODE
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPersonType.vb`
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPersonList.vb`

---

## LEGAL.VW_CASES

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `LEGAL` |
| **Purpose** | Used by clsLetterRequest case lookup (view) |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsLetterRequest case lookup (view)` |

### Sources for LEGAL.VW_CASES
- `SAIF.Business.Claim.Legal\Print\clsLetterRequest.vb:730`

---

## NATURE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsNatureCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsNatureCodes` |

### Sources for NATURE_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## NOTE_CATEGORY_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsNoteCategoryCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsNoteCategoryCodes` |

### Sources for NOTE_CATEGORY_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## ORDER_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsOrderTypeCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsOrderTypeCodes` |

### Sources for ORDER_TYPE_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## OTHER_FIRM

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsOtherFirm (+collection) |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | OTHER_FIRM_SEQ_NUM |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsOtherFirm (+collection)` |

### Sources for OTHER_FIRM
- `SAIF.Business.Claim.Legal\TableMaint\clsOtherFirm.vb`
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEmployer.vb`

---

## OTHER_FIRM_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsOtherFirmTypeCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsOtherFirmTypeCodes` |

### Sources for OTHER_FIRM_TYPE_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## OUTCOME_GROUNDS_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsOutcomeGroundsCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsOutcomeGroundsCodes` |

### Sources for OUTCOME_GROUNDS_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## OUTCOME_ISSUE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsOutcomeIssue (+collection) |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | OUTCOME_ISSUE_SEQ |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsOutcomeIssue (+collection)` |

### Sources for OUTCOME_ISSUE
- `SAIF.Business.Claim.Legal\LegalNet\clsOutcomeIssue.vb`

---

## OUTCOME_ISSUE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsOutcomeIssueCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsOutcomeIssueCodes` |

### Sources for OUTCOME_ISSUE_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## OUTCOME_STAFF

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsOutcomeStaff (+collection) |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | OUTCOME_STAFF_SEQ_NUM |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsOutcomeStaff (+collection)` |

### Sources for OUTCOME_STAFF
- `SAIF.Business.Claim.Legal\LegalNet\clsOutcomeStaff.vb`

---

## OUT_OF_TOWN_ROTATION_ASSGN

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsOutOFTownRotationAssgn (+collection) |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | OUT_OF_TOWN_ROTATION_SEQ_NUM |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsOutOFTownRotationAssgn (+collection)` |

### Sources for OUT_OF_TOWN_ROTATION_ASSGN
- `SAIF.Business.Claim.Legal\TableMaint\clsOutOFTownRotationAssgn.vb`

---

## PETITIONER_RESPONDENT_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsPetitionerRespondentCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsPetitionerRespondentCodes` |

### Sources for PETITIONER_RESPONDENT_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## POLICY

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by Policy join for conflicts / policy assignment |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `Policy join for conflicts / policy assignment` |

### Sources for POLICY
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb`
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyPolicyAssignment.vb`

---

## PROVIDER_LOCATION

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by Outside-counsel firm location join |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `Outside-counsel firm location join` |

### Sources for PROVIDER_LOCATION
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb`
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## REQUESTED_BY_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsRequestedByCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsRequestedByCodes` |

### Sources for REQUESTED_BY_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## REQUEST_ISSUE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsRequestIssue (+collection) |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | REQUEST_ISSUE_SEQ |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsRequestIssue (+collection)` |

### Sources for REQUEST_ISSUE
- `SAIF.Business.Claim.Legal\LegalNet\clsRequestIssue.vb`

---

## REQUEST_ISSUE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsRequestIssueCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsRequestIssueCodes` |

### Sources for REQUEST_ISSUE_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## REQUEST_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsRequestTypeCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsRequestTypeCodes` |

### Sources for REQUEST_TYPE_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## REVIEW_LEVEL_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsReviewLevelCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsReviewLevelCodes` |

### Sources for REVIEW_LEVEL_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## SCHEDULE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsLegalSchedule, clsHearingLocation.CanDeleteLocation |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | SCHEDULE_SEQ (create via proc) |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsLegalSchedule, clsHearingLocation.CanDeleteLocation` |

### Sources for SCHEDULE
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalSchedule.vb`
- `SAIF.Business.Claim.Legal\TableMaint\clsHearingLocation.vb`

---

## SCHEDULE_STATUS_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsScheduleStatusCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsScheduleStatusCodes` |

### Sources for SCHEDULE_STATUS_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## SCHEDULE_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsScheduleTypeCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsScheduleTypeCodes` |

### Sources for SCHEDULE_TYPE_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## SERVICE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsServiceCodes |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsServiceCodes` |

### Sources for SERVICE_CODE
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## SUBPOENA_RECIPIENT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Used by clsLegalPerson delete-guard (NOT EXISTS) |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | Read |
| **Key columns used** | See SQL catalog entries referencing this table |
| **Sequence** | — |
| **Related tables** | See [Table relationship diagram](#table-relationship-diagram) below |
| **Business objects** | `clsLegalPerson delete-guard (NOT EXISTS)` |

### Sources for SUBPOENA_RECIPIENT
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPerson.vb`

---

## Table relationship diagram

The following diagram shows verified relationships between tables used by this library (explicit JOIN or correlated predicate in repository SQL).

```mermaid
erDiagram
    ADP_EMPLOYEE ||--o{ ATTORNEY_CONFLICT : "ADJUSTER_EMPLID"
    PROVIDER_LOCATION ||--o{ ATTORNEY_CONFLICT : "PROVIDER_LOCATION_SEQ_NUM"
    POLICY ||--o{ ATTORNEY_CONFLICT : "POLICY_NUM"
    LEGAL_PERSON ||--o{ ATTORNEY_CONFLICT : "CONFLICT_LEGAL_PERSON_SEQ_NUM"
    ATTORNEY_PROFILE ||--o{ ATTORNEY_CONFLICT : "ATTORNEY_EMPLID"
    ADP_EMPLOYEE ||--o{ ATTORNEY_POLICY_ASSIGNMENT : "PRIMARY_SECONDARY_TERTIARY_EMPLID"
    POLICY ||--o{ ATTORNEY_POLICY_ASSIGNMENT : "POLICY_NUM"
    ADP_EMPLOYEE ||--o{ ATTORNEY_SCHEDULE : "SCHEDULE_EMPLID"
    ADP_EMPLOYEE ||--o{ ATTORNEY_WORKER_ASSIGNMENT : "ATTORNEY_EMPLID"
    ADP_EMPLOYEE ||--o{ OUT_OF_TOWN_ROTATION_ASSGN : "ATTORNEY_EMPLID"
    ADP_EMPLOYEE ||--o{ ATTORNEY_PROFILE : "PROFILE_EMPLID"
    OTHER_FIRM ||--o{ LEGAL_CASE_EMPLOYER : "OTHER_FIRM_SEQ_NUM"
    LEGAL_PERSON ||--o{ LEGAL_CASE_EMPLOYER : "LEGAL_PERSON_SEQ_NUM"
    HEARING_LOCATION_CODE ||--o{ HEARING_LOCATION : "HEARING_LOCATION_CODE"
    LEGAL_PERSON ||--o{ LEGAL_PERSON_TYPE : "LEGAL_PERSON_SEQ_NUM"
    LEGAL_PERSON_TYPE_CODE ||--o{ LEGAL_PERSON_TYPE : "LEGAL_PERSON_TYPE_CODE"
    LEGAL_PERSON ||--o{ SUBPOENA_RECIPIENT : "LEGAL_PERSON_SEQ_NUM (delete guard)"
    HEARING_LOCATION ||--o{ SCHEDULE : "HEARING_LOCATION_SEQ_NUM (delete guard)"
    OTHER_FIRM_TYPE_CODE ||--o{ OTHER_FIRM : "OTHER_FIRM_TYPE_CODE"
    OUTCOME_ISSUE_CODE ||--o{ OUTCOME_ISSUE : "OUTCOME_ISSUE_CODE"
    REQUEST_ISSUE_CODE ||--o{ REQUEST_ISSUE : "REQUEST_ISSUE_CODE"
```

Additional relationships are inferred from `*_SEQ_NUM` naming conventions but have no explicit JOIN in repository SQL (e.g. `LEGAL_CASE` to `CASE_COST`, `CASE_STATUS_HISTORY`, `LEGAL_CASE_EMPLOYER`, `LEGAL_CASE_EVALUATION`, `LEGAL_FILE_LOCATION`, `REQUEST_ISSUE`, `SCHEDULE` via `LEGAL_CASE_SEQ_NUM`; `CASE_OUTCOME` to `OUTCOME_ISSUE`/`OUTCOME_STAFF` via `CASE_OUTCOME_SEQ_NUM`; `APPEAL` to `APPEAL_EXTENSION` via `APPEAL_SEQ_NUM`).* No `FOREIGN KEY` constraint DDL exists in this repository; all relationships are derived from query text or naming.**

## Related documentation
- [Index](index.md)
- [Overview](overview.md)
- [Architecture](architecture.md)
- [Dependencies](dependencies.md)
- [Configuration](configuration.md)
- [Operations and processes](operations-processes.md)
- [Business rules](business-rules.md)
- [SQL catalog](sql/index.md)
- [Procedures](procedures/index.md)
- [API reference](api/index.md)

> **Note:** Statements marked with `*` were inferred from code structure, naming
> conventions, or contextual evidence where direct confirmation was not available
> in source artifacts. Statements marked with `**` could not be confirmed; treat
> as unknown until verified.

## Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCase.vb`
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalSchedule.vb`
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb`
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyPolicyAssignment.vb`
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneySchedule.vb`
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyWorkerAssignment.vb`
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyProfile.vb`
- `SAIF.Business.Claim.Legal\TableMaint\clsHearingLocation.vb`
- `SAIF.Business.Claim.Legal\TableMaint\clsOtherFirm.vb`
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPerson.vb`
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPersonType.vb`
- `SAIF.Business.Claim.Legal\TableMaint\clsOutOFTownRotationAssgn.vb`
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseCost.vb`
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseStatusHistory.vb`
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEmployer.vb`
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEvaluation.vb`
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalFileLocation.vb`
- `SAIF.Business.Claim.Legal\LegalNet\clsOutcomeIssue.vb`
- `SAIF.Business.Claim.Legal\LegalNet\clsOutcomeStaff.vb`
- `SAIF.Business.Claim.Legal\LegalNet\clsRequestIssue.vb`
- `SAIF.Business.Claim.Legal\LegalNet\clsAppealExtension.vb`
- `SAIF.Business.Claim.Legal\Print\clsLetterRequest.vb`